EXEC sp_resetstatus 'tng';
ALTER DATABASE tng SET EMERGENCY
DBCC checkdb('tng')
ALTER DATABASE tng SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('tng', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE tng SET MULTI_USER